Excel 2007 & 2010 NOW Function

The NOW function, one of Excel's date and time functions, is used to add the current time and date to a spreadsheet.

The syntax for the NOW function is:

= NOW ( )

1. Click on cell D1 - the location where the results will be displayed.
   
   
2. Click on the Formulas tab.
   
   
3. Choose Date & Time from the ribbon to open the function drop down list.
   
   
4. Click on NOW in the list to bring up the function's dialog box.
   
   
5. Click OK.
   
   
6. The current time and date should appear in cell D1.
   
   
7. When you click on cell D1 the complete function = NOW ( ) appears in the formula bar above the worksheet.
   
   
8. If you want cell D1 to show only the current time or date, change the cell's format to show either time or date only.

---

---